UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '//7T7tyTC0R75yRa5HopVAbP5lF1cbLBAWVPWYxWwGM='
WHERE
key_id = '56a606b26190f733008603d4f96d97b19713e02bceff142ce2de6b01ffa5c327'
AND (
token = '//7T7tyTC0R75yRa5HopVAbP5lF1cbLBAWVPWYxWwGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)