UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n6mlXnlWrCXIdfEOniaCK9h9zhqj7+AyCyxxiB5gnAE='
WHERE
key_id = '505015963e205952c6e7d0aa8ec4a190b353581b53ca576373f12307591f8528'
AND (
token = 'n6mlXnlWrCXIdfEOniaCK9h9zhqj7+AyCyxxiB5gnAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)