UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JuQKV/+bGIwgSBTfEvG97T58PeYez08goYb/KZHnlhk='
WHERE
key_id = '8277e967dd9d246bf934bc05bfd36b8576d6a311dbf54b0733448b0fa9190615'
AND (
token = 'JuQKV/+bGIwgSBTfEvG97T58PeYez08goYb/KZHnlhk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)