UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5GnI9/WCV0iqRp3OqwEOgyQub5yGnHv1CGKSTzpi9rY='
WHERE
key_id = 'b2f9ce3f9956d817ed8fb1f0f27f45f1d0afb35e112813d16f68466882ba597e'
AND (
token = '5GnI9/WCV0iqRp3OqwEOgyQub5yGnHv1CGKSTzpi9rY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)