UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TTNIV63dvgqVW5BIvx1vs9OHremmd0ImYGf2uWQmHr8='
WHERE
key_id = '29b151b58368485f3a749e14d26e6028595a2b6269381f3c6d1f1b52a224fad3'
AND (
token = 'TTNIV63dvgqVW5BIvx1vs9OHremmd0ImYGf2uWQmHr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)