UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+CZS4SVY6l/5CGUTIjOd0vDNiGXVSoLJRGjck/IF3po='
WHERE
key_id = 'dfe6e3972c1990bf71d9e296dfed582c553ec18c979e7e2384673a8e2f78d80a'
AND (
token = '+CZS4SVY6l/5CGUTIjOd0vDNiGXVSoLJRGjck/IF3po='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)