UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DZy1x4zjVSFNADJV7WnfHdo398QmKeurw3QXci6UDW4='
WHERE
key_id = '46acce8987c10e7ef24aa7bc02d96c08ac104a4627f0d950cbc4e4e1e32e02cd'
AND (
token = 'DZy1x4zjVSFNADJV7WnfHdo398QmKeurw3QXci6UDW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)