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