UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qrUTfRTZaPlGLq44aE886T8Dz79WzgQ1TZYwrP+aGrc='
WHERE
key_id = '7d395c734261809766c3bbf26c09e5cc71574e2dc6e526f4a4d9cc2db336599f'
AND (
token = 'qrUTfRTZaPlGLq44aE886T8Dz79WzgQ1TZYwrP+aGrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)