UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mgpinqwj5uok0LJ3wX30Z4Ob0y16PC1eN9Aj+xAUJQ4='
WHERE
key_id = '00a4b41ef5ba1d9c3ab75a0cdebfbb50e47babcd1f477362534f26eda3e5ca6a'
AND (
token = 'Mgpinqwj5uok0LJ3wX30Z4Ob0y16PC1eN9Aj+xAUJQ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)