UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r7q2Q6huU0B4fmBCLqXBqv1fQzgdg1AWHvms3BcLhws='
WHERE
key_id = '4a7f52e22991a5c1048b0cf66371f55d9811da01b7d45ba6555b194fc03943a8'
AND (
token = 'r7q2Q6huU0B4fmBCLqXBqv1fQzgdg1AWHvms3BcLhws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)