UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n09I4GukijVbRSaF+x2U7w07diihRs6w1qKJ9U8aPJo='
WHERE
key_id = '0154677d3c4c9a7af2b69ca5a7cf74bc8203ad46384e4395974277508f176ff2'
AND (
token = 'n09I4GukijVbRSaF+x2U7w07diihRs6w1qKJ9U8aPJo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)