UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X12YwEiB6U0MSrDOWwdb4R91NFKEmKF/r5rBt+n5tF0='
WHERE
key_id = 'a8b06d4181e7b366a4ca0f0a27b68788ce17bfc17ad52fca0bec4970e71bd0af'
AND (
token = 'X12YwEiB6U0MSrDOWwdb4R91NFKEmKF/r5rBt+n5tF0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)