UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cXhPNk8w4zSmGipOA6yybZVy9KbToo3KdpOxQD3ywNw='
WHERE
key_id = '20ccde4720818c76ddd0eb9de179801254968d113b2055278cec8e993f078da1'
AND (
token = 'cXhPNk8w4zSmGipOA6yybZVy9KbToo3KdpOxQD3ywNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)