UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '18T68BlkvfZHb0BSeqbB0iTuvse4xjKzLkPPiKgTn6U='
WHERE
key_id = 'ed1848aec9a4b830a6d9df491723c68eb3319b61960721878a16152efc8f3570'
AND (
token = '18T68BlkvfZHb0BSeqbB0iTuvse4xjKzLkPPiKgTn6U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)