UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7X3T0tZWVoA8sRx0IKc/GvFxUfr+TweBhI8p6Om8Ho8='
WHERE
key_id = 'c46f9140e2a5b6bb1eb88c793f5284b0337231d0081efabc82022847635ee14f'
AND (
token = '7X3T0tZWVoA8sRx0IKc/GvFxUfr+TweBhI8p6Om8Ho8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)