UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h4adydJHgyP5O/nduH32E9HGHM5+mAQw/2uFPalu6go='
WHERE
key_id = 'ab71fc9b9fd048debaf3c22b79e124fd7cfbfd1b7e89d79cd16e250f6491e7b6'
AND (
token = 'h4adydJHgyP5O/nduH32E9HGHM5+mAQw/2uFPalu6go='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)