UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kwkHMa/vQWIoI7e7knRCuOQJyJ5GNZ87DQBFPVNNt30='
WHERE
key_id = '2f98a86c55bee02695815b37d8a286586e041d0f77a72775d7988592bad53f4c'
AND (
token = 'kwkHMa/vQWIoI7e7knRCuOQJyJ5GNZ87DQBFPVNNt30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)