UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'buQGBWvij8cLa687X9ch3D6kIQLxKUQ1V9bqebquSXI='
WHERE
key_id = '9f8f5025ebec6c4e0d8dd6dfe5828a2bdb8c8564da77ae9383aa4c2c3c62930d'
AND (
token = 'buQGBWvij8cLa687X9ch3D6kIQLxKUQ1V9bqebquSXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)