UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ghBgXpkmc40kYiK8zSz6ZbA2pURG6pju4my8jSJKTDY='
WHERE
key_id = 'c30ae2c8703926ec8c7bf1d25cde1ccc028b3201989986158c3875bb6fbc0f76'
AND (
token = 'ghBgXpkmc40kYiK8zSz6ZbA2pURG6pju4my8jSJKTDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)