UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0wdBljsAtRniWiGsR7v5TSatOLtodgMWaVYMy2zDtqI='
WHERE
key_id = 'af539776339e2b41a8aebf2649f00c642ec4717d86165d10bec9304753306bea'
AND (
token = '0wdBljsAtRniWiGsR7v5TSatOLtodgMWaVYMy2zDtqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)