UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ziTYYhuB3DdIWKErU9yJM2z6K4f2aX8UBXImOuLmHEA='
WHERE
key_id = '0b0b253b2e51c19984eb08e71efef7871f529e2a933e40084c83ba492b48f99f'
AND (
token = 'ziTYYhuB3DdIWKErU9yJM2z6K4f2aX8UBXImOuLmHEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)