UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMzT4SCXNYDU2VQZvIit2cyLXHhhfFPLXzkwmmBDQRo='
WHERE
key_id = '350353b8edabb62f3017737c3c6ce54b6a5111258c758e06de25a91ab08913ab'
AND (
token = 'BMzT4SCXNYDU2VQZvIit2cyLXHhhfFPLXzkwmmBDQRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)