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