UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pn+A/mOaFuoQgpX5S1oo1qU6MFGUoZYAFAgteD2mH3c='
WHERE
key_id = '8be2163ed36dba597495b4cd73225043b4ee5208a9e6db53a3e183f05681ddf9'
AND (
token = 'pn+A/mOaFuoQgpX5S1oo1qU6MFGUoZYAFAgteD2mH3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)