UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pYaw1HiKXOMvTk+PUbolmX5mqHg8hxaBSAbtDRoiryo='
WHERE
key_id = '557cc9d5f575d3e569d66660cb10cf96a4ebd7e28888589cd0dc4b9b52b96f0e'
AND (
token = 'pYaw1HiKXOMvTk+PUbolmX5mqHg8hxaBSAbtDRoiryo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)