UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '734zPFVye3s9FMBVV204CrlvAGL7N4wyt0cFfSSuEu8='
WHERE
key_id = 'd3e6f4dfccbefad0d3e72b4fa368ba5f3bc1665f1ff7092519aa34af9ef81691'
AND (
token = '734zPFVye3s9FMBVV204CrlvAGL7N4wyt0cFfSSuEu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)