UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gv/gLmdgvzjq67OKj7AOhCem3DQI7t+gUvD4Y7h33CE='
WHERE
key_id = '1904bb100face5d4ffcc65e4f70b4de577a1de4c93ae8993cae21bffdef73397'
AND (
token = 'gv/gLmdgvzjq67OKj7AOhCem3DQI7t+gUvD4Y7h33CE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)