UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AmBpNG99E8cOJj/y1qvyRdqvNyi9+HhXFAspcdiS/y4='
WHERE
key_id = 'f70321cf27768f3df7b3359289d12f31e028e40d477ceeebe02fdfe03dc27baa'
AND (
token = 'AmBpNG99E8cOJj/y1qvyRdqvNyi9+HhXFAspcdiS/y4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)