UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/VvynWd+pBuhoKQrXU6j64sBBCUBETOSCJMocuWIJr8='
WHERE
key_id = '4e6ee826384c4e4f4c4c0ca5449355d9270104f0126d252d602dd0be442a4339'
AND (
token = '/VvynWd+pBuhoKQrXU6j64sBBCUBETOSCJMocuWIJr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)