UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dPiwH0vn5Aybo6pCFb5144GVUfb7ddSsPnp47AyIXbk='
WHERE
key_id = '9db0eb951e2df84f09357ebab3694e5593bee1d39fc0262ca2736a796e5de8f6'
AND (
token = 'dPiwH0vn5Aybo6pCFb5144GVUfb7ddSsPnp47AyIXbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)