UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pp0jIOUNFYEqAHx9hzTigWPue1uGoK67fBWS+OYi5VY='
WHERE
key_id = '6fec0d1b4f7e97b387cff64e8a1cefb8f8dfe99f7bc4dceddd77d7c066f9148f'
AND (
token = 'pp0jIOUNFYEqAHx9hzTigWPue1uGoK67fBWS+OYi5VY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)