UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XnbCu1gSum8s3rXcjLU8OTYDz7U3Zp0fV4ttCDbgZIQ='
WHERE
key_id = 'be99ba754910fc18aee742deef44520a2e77549c1fd8d469a236b602ea5f4dde'
AND (
token = 'XnbCu1gSum8s3rXcjLU8OTYDz7U3Zp0fV4ttCDbgZIQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)