UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2WG/JqhwP7Uxna2duDow+5mKWOPglQpVrDdtTPPGxI8='
WHERE
key_id = '1f9dc2e38be07d78439aefa0ba4c665c179f99c79a52d1bd1f9f78231ec95800'
AND (
token = '2WG/JqhwP7Uxna2duDow+5mKWOPglQpVrDdtTPPGxI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)