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