UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SLgrkC2RyK1G0YsS/CK7piJ5Upvp/S3FfWTuCz4GAqc='
WHERE
key_id = '33066df77206a02ab862b6b4413f114ac910fe36a4fa0acbf8fd64accc7cc54f'
AND (
token = 'SLgrkC2RyK1G0YsS/CK7piJ5Upvp/S3FfWTuCz4GAqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)