UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'blTwkEvBiAA7BwxUNBIqFgirOPCBhBGda52UUjldLgw='
WHERE
key_id = 'b026ec3b29ff2f298b8d64c511218a698de0d0644f999fab5d4ebf470ff64dd0'
AND (
token = 'blTwkEvBiAA7BwxUNBIqFgirOPCBhBGda52UUjldLgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)