UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KM3xjHYAx9CAtRAo2bTUW1roHNNRtX7b5BHgOKAS7kU='
WHERE
key_id = '75184f6011b9ba54bb89e7593def71832506a7ff7c5789a902de534a86867d3e'
AND (
token = 'KM3xjHYAx9CAtRAo2bTUW1roHNNRtX7b5BHgOKAS7kU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)