UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dqCOo7L+Vek2ku3hGiWu39QsDYhuQPr5jerha6lS7PU='
WHERE
key_id = 'bf4c6cd2a6a5a7ad16ee05d49a690fbb66340a526e739bd256487f21673814e4'
AND (
token = 'dqCOo7L+Vek2ku3hGiWu39QsDYhuQPr5jerha6lS7PU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)