UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LGrGdjNJiX50neoh0uuDPV6WLEy39aa/RVSNsFHeDfk='
WHERE
key_id = '39469bcb8a509589b4ecbefa7d3d265832662754764a055d1c1a09fbdddc10e5'
AND (
token = 'LGrGdjNJiX50neoh0uuDPV6WLEy39aa/RVSNsFHeDfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)