UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XK5U263Ju62HKWTw2lFADLe7fyZFNnkJcRJGeezeCD8='
WHERE
key_id = '029df9267470d2d963313a066ed24d3eefd453dd9bb7150013fcc51f2cde6ad5'
AND (
token = 'XK5U263Ju62HKWTw2lFADLe7fyZFNnkJcRJGeezeCD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)