UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b6D4yu6h8xq9D0/LAE6ximTSB0g7i/ADXieWeqfbh1o='
WHERE
key_id = '78821e7eee4fcc79c6f217cb8939cbe31dda7a81e1b031c0aeb5c76a996be888'
AND (
token = 'b6D4yu6h8xq9D0/LAE6ximTSB0g7i/ADXieWeqfbh1o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)