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